package com.cjgl.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.cjgl.model.entity.TblCourses;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @author zhangyuwu
 * @description 针对表【tbl_courses(课程)】的数据库操作Mapper
 * @createDate 2023-05-24 13:49:32
 * @Entity com.cjgl.model.entity.TblCourses
 */
public interface TblCoursesMapper extends BaseMapper<TblCourses> {


	/**
	 * 查询某个学生没选过的课
	 */
	@Select("select * from tbl_courses where courseNo not in (select courseNo from tbl_scores where studentNo=#{studentNo})")
	public List<TblCourses> getNotSelectedCourse(String studentNo);
}




